Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	6255
Missing cells	21762
Missing cells (%)	26.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	592.6 KiB
Average record size in memory	97.0 B

Variable types

Numeric	11
Categorical	1
Boolean	1

Alerts

`Date` has a high cardinality: 139 distinct values	High cardinality
`id` is highly correlated with `Store`	High correlation
`Store` is highly correlated with `id`	High correlation
`Promotion1` is highly correlated with `Promotion4` and 2 other fields	High correlation
`Promotion4` is highly correlated with `Promotion1`	High correlation
`Promotion5` is highly correlated with `Promotion1` and 1 other fields	High correlation
`Weekly_Sales` is highly correlated with `Promotion1` and 1 other fields	High correlation
`id` is highly correlated with `Store`	High correlation
`Store` is highly correlated with `id`	High correlation
`Promotion1` is highly correlated with `Promotion4`	High correlation
`Promotion4` is highly correlated with `Promotion1`	High correlation
`id` is highly correlated with `Store`	High correlation
`Store` is highly correlated with `id`	High correlation
`Promotion1` is highly correlated with `Promotion4`	High correlation
`Promotion4` is highly correlated with `Promotion1`	High correlation
`id` is highly correlated with `Store` and 2 other fields	High correlation
`Store` is highly correlated with `id` and 2 other fields	High correlation
`Fuel_Price` is highly correlated with `Unemployment`	High correlation
`Promotion1` is highly correlated with `Promotion4`	High correlation
`Promotion4` is highly correlated with `Promotion1`	High correlation
`Unemployment` is highly correlated with `id` and 2 other fields	High correlation
`Weekly_Sales` is highly correlated with `id` and 1 other fields	High correlation
`Promotion1` has 4153 (66.4%) missing values	Missing
`Promotion2` has 4663 (74.5%) missing values	Missing
`Promotion3` has 4370 (69.9%) missing values	Missing
`Promotion4` has 4436 (70.9%) missing values	Missing
`Promotion5` has 4140 (66.2%) missing values	Missing
`id` is uniformly distributed	Uniform
`Date` is uniformly distributed	Uniform
`id` has unique values	Unique
`Weekly_Sales` has unique values	Unique

Reproduction

Analysis started	2022-07-20 02:39:39.731113
Analysis finished	2022-07-20 02:40:03.825868
Duration	24.09 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	6255
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3128

Minimum	1
Maximum	6255
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	1
5-th percentile	313.7
Q1	1564.5
median	3128
Q3	4691.5
95-th percentile	5942.3
Maximum	6255
Range	6254
Interquartile range (IQR)	3127

Descriptive statistics

Standard deviation	1805.807299
Coefficient of variation (CV)	0.5773041236
Kurtosis	-1.2
Mean	3128
Median Absolute Deviation (MAD)	1564
Skewness	0
Sum	19565640
Variance	3260940
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
4155	1	< 0.1%
4177	1	< 0.1%
4176	1	< 0.1%
4175	1	< 0.1%
4174	1	< 0.1%
4173	1	< 0.1%
4172	1	< 0.1%
4171	1	< 0.1%
4170	1	< 0.1%
Other values (6245)	6245	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
6255	1	< 0.1%
6254	1	< 0.1%
6253	1	< 0.1%
6252	1	< 0.1%
6251	1	< 0.1%
6250	1	< 0.1%
6249	1	< 0.1%
6248	1	< 0.1%
6247	1	< 0.1%
6246	1	< 0.1%

Store
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	45
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23

Minimum	1
Maximum	45
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	12
median	23
Q3	34
95-th percentile	43
Maximum	45
Range	44
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	12.98821143
Coefficient of variation (CV)	0.5647048447
Kurtosis	-1.201186658
Mean	23
Median Absolute Deviation (MAD)	11
Skewness	0
Sum	143865
Variance	168.6936361
Monotonicity	Increasing

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
1	139	2.2%
24	139	2.2%
26	139	2.2%
27	139	2.2%
28	139	2.2%
29	139	2.2%
30	139	2.2%
31	139	2.2%
32	139	2.2%
33	139	2.2%
Other values (35)	4865	77.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	139	2.2%
2	139	2.2%
3	139	2.2%
4	139	2.2%
5	139	2.2%
6	139	2.2%
7	139	2.2%
8	139	2.2%
9	139	2.2%
10	139	2.2%

Value	Count	Frequency (%)
45	139	2.2%
44	139	2.2%
43	139	2.2%
42	139	2.2%
41	139	2.2%
40	139	2.2%
39	139	2.2%
38	139	2.2%
37	139	2.2%
36	139	2.2%

Date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	139
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	49.0 KiB

05/02/2010	45
02/12/2011	45
21/10/2011	45
28/10/2011	45
04/11/2011	45
Other values (134)	6030

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	05/02/2010
2nd row	12/02/2010
3rd row	19/02/2010
4th row	26/02/2010
5th row	05/03/2010

Common Values

Value	Count	Frequency (%)
05/02/2010	45	0.7%
02/12/2011	45	0.7%
21/10/2011	45	0.7%
28/10/2011	45	0.7%
04/11/2011	45	0.7%
11/11/2011	45	0.7%
18/11/2011	45	0.7%
25/11/2011	45	0.7%
09/12/2011	45	0.7%
03/02/2012	45	0.7%
Other values (129)	5805	92.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
05/02/2010	45	0.7%
09/04/2010	45	0.7%
21/05/2010	45	0.7%
14/05/2010	45	0.7%
07/05/2010	45	0.7%
30/04/2010	45	0.7%
23/04/2010	45	0.7%
16/04/2010	45	0.7%
02/04/2010	45	0.7%
08/10/2010	45	0.7%
Other values (129)	5805	92.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Temperature
Real number (ℝ)

Distinct	3470
Distinct (%)	55.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.63919904

Minimum	-2.06
Maximum	100.14
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	49.0 KiB

Quantile statistics

Minimum	-2.06
5-th percentile	27.525
Q1	47.17
median	62.72
Q3	75.22
95-th percentile	87.765
Maximum	100.14
Range	102.2
Interquartile range (IQR)	28.05

Descriptive statistics

Standard deviation	18.62409426
Coefficient of variation (CV)	0.3071296217
Kurtosis	-0.6450981937
Mean	60.63919904
Median Absolute Deviation (MAD)	13.95
Skewness	-0.3330630907
Sum	379298.19
Variance	346.8568872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50.43	11	0.2%
67.87	10	0.2%
72.62	9	0.1%
76.67	9	0.1%
64.05	8	0.1%
64.21	8	0.1%
70.87	7	0.1%
76.03	7	0.1%
50.56	7	0.1%
44.42	7	0.1%
Other values (3460)	6172	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.06	1	< 0.1%
5.54	1	< 0.1%
6.23	1	< 0.1%
7.46	1	< 0.1%
9.51	1	< 0.1%
9.55	1	< 0.1%
10.09	1	< 0.1%
10.11	1	< 0.1%
10.24	1	< 0.1%
10.53	1	< 0.1%

Value	Count	Frequency (%)
100.14	1	< 0.1%
100.07	1	< 0.1%
99.66	1	< 0.1%
99.22	3	< 0.1%
99.2	1	< 0.1%
98.43	1	< 0.1%
98.15	1	< 0.1%
97.66	1	< 0.1%
97.6	1	< 0.1%
97.18	3	< 0.1%

Fuel_Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	877
Distinct (%)	14.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.344369305

Minimum	2.472
Maximum	4.308
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	2.472
5-th percentile	2.642
Q1	2.917
median	3.413
Q3	3.722
95-th percentile	4.0216
Maximum	4.308
Range	1.836
Interquartile range (IQR)	0.805

Descriptive statistics

Standard deviation	0.4553641003
Coefficient of variation (CV)	0.1361584379
Kurtosis	-1.219720747
Mean	3.344369305
Median Absolute Deviation (MAD)	0.39
Skewness	-0.08215093034
Sum	20919.03
Variance	0.2073564638
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.638	39	0.6%
3.63	34	0.5%
3.891	29	0.5%
2.771	29	0.5%
3.524	28	0.4%
2.72	28	0.4%
3.666	27	0.4%
3.523	27	0.4%
3.842	25	0.4%
3.129	25	0.4%
Other values (867)	5964	95.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.472	1	< 0.1%
2.513	1	< 0.1%
2.514	14	0.2%
2.52	1	< 0.1%
2.533	1	< 0.1%
2.539	1	< 0.1%
2.54	2	< 0.1%
2.542	1	< 0.1%
2.545	1	< 0.1%
2.548	14	0.2%

Value	Count	Frequency (%)
4.308	3	< 0.1%
4.294	6	0.1%
4.293	3	< 0.1%
4.288	3	< 0.1%
4.282	3	< 0.1%
4.277	6	0.1%
4.273	6	0.1%
4.254	6	0.1%
4.25	3	< 0.1%
4.222	3	< 0.1%

Promotion1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2099
Distinct (%)	99.9%
Missing	4153
Missing (%)	66.4%
Infinite	0
Infinite (%)	0.0%
Mean	7155.930661

Minimum	0.27
Maximum	88646.76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	0.27
5-th percentile	98.194
Q1	1844.295
median	5221.14
Q3	9199.2425
95-th percentile	21966.923
Maximum	88646.76
Range	88646.49
Interquartile range (IQR)	7354.9475

Descriptive statistics

Standard deviation	8408.206085
Coefficient of variation (CV)	1.174998261
Kurtosis	17.05655515
Mean	7155.930661
Median Absolute Deviation (MAD)	3658.545
Skewness	3.281296742
Sum	15041766.25
Variance	70697929.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
175.64	2	< 0.1%
460.73	2	< 0.1%
1.5	2	< 0.1%
292.53	1	< 0.1%
799.32	1	< 0.1%
200.86	1	< 0.1%
164.49	1	< 0.1%
92.13	1	< 0.1%
283.01	1	< 0.1%
971.97	1	< 0.1%
Other values (2089)	2089	33.4%
(Missing)	4153	66.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.27	1	< 0.1%
0.5	1	< 0.1%
1.5	2	< 0.1%
1.94	1	< 0.1%
2.12	1	< 0.1%
2.4	1	< 0.1%
2.42	1	< 0.1%
2.43	1	< 0.1%
2.8	1	< 0.1%
2.91	1	< 0.1%

Value	Count	Frequency (%)
88646.76	1	< 0.1%
78124.5	1	< 0.1%
75149.79	1	< 0.1%
65021.23	1	< 0.1%
62567.6	1	< 0.1%
62172.73	1	< 0.1%
60740.64	1	< 0.1%
60394.73	1	< 0.1%
58928.52	1	< 0.1%
56917.7	1	< 0.1%

Promotion2
Real number (ℝ)

MISSING

Distinct	1457
Distinct (%)	91.5%
Missing	4663
Missing (%)	74.5%
Infinite	0
Infinite (%)	0.0%
Mean	3308.12581

Minimum	-265.76
Maximum	104519.54
Zeros	3
Zeros (%)	< 0.1%
Negative	18
Negative (%)	0.3%
Memory size	49.0 KiB

Quantile statistics

Minimum	-265.76
5-th percentile	1.91
Q1	39.755
median	205.41
Q3	1931.005
95-th percentile	15721.981
Maximum	104519.54
Range	104785.3
Interquartile range (IQR)	1891.25

Descriptive statistics

Standard deviation	9382.823804
Coefficient of variation (CV)	2.83629594
Kurtosis	38.08772863
Mean	3308.12581
Median Absolute Deviation (MAD)	198.42
Skewness	5.466413849
Sum	5266536.29
Variance	88037382.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.5	9	0.1%
0.5	9	0.1%
1.91	8	0.1%
3	7	0.1%
6	6	0.1%
4	6	0.1%
19	5	0.1%
3.82	5	0.1%
7.64	5	0.1%
5.73	5	0.1%
Other values (1447)	1527	24.4%
(Missing)	4663	74.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-265.76	1	< 0.1%
-192	1	< 0.1%
-20	1	< 0.1%
-10.98	1	< 0.1%
-10.5	2	< 0.1%
-9.98	1	< 0.1%
-9.94	1	< 0.1%
-7.6	1	< 0.1%
-6.69	1	< 0.1%
-5.98	1	< 0.1%

Value	Count	Frequency (%)
104519.54	1	< 0.1%
97740.99	1	< 0.1%
92523.94	1	< 0.1%
89121.94	1	< 0.1%
82881.16	1	< 0.1%
72413.71	1	< 0.1%
70574.85	1	< 0.1%
58804.91	1	< 0.1%
58046.41	1	< 0.1%
56106.2	1	< 0.1%

Promotion3
Real number (ℝ)

MISSING

Distinct	1562
Distinct (%)	82.9%
Missing	4370
Missing (%)	69.9%
Infinite	0
Infinite (%)	0.0%
Mean	1462.535523

Minimum	-29.1
Maximum	141630.61
Zeros	1
Zeros (%)	< 0.1%
Negative	4
Negative (%)	0.1%
Memory size	49.0 KiB

Quantile statistics

Minimum	-29.1
5-th percentile	0.6
Q1	4.7
median	24.6
Q3	104.01
95-th percentile	1073.828
Maximum	141630.61
Range	141659.71
Interquartile range (IQR)	99.31

Descriptive statistics

Standard deviation	9667.580258
Coefficient of variation (CV)	6.610150734
Kurtosis	76.23384752
Mean	1462.535523
Median Absolute Deviation (MAD)	22.8
Skewness	8.313267116
Sum	2756879.46
Variance	93462108.05
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	10	0.2%
2	9	0.1%
1	9	0.1%
0.22	7	0.1%
0.5	6	0.1%
0.6	6	0.1%
0.01	6	0.1%
6	6	0.1%
1.98	6	0.1%
3.2	6	0.1%
Other values (1552)	1814	29.0%
(Missing)	4370	69.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-29.1	1	< 0.1%
-1	1	< 0.1%
-0.87	1	< 0.1%
-0.2	1	< 0.1%
0	1	< 0.1%
0.01	6	0.1%
0.02	1	< 0.1%
0.04	4	0.1%
0.05	1	< 0.1%
0.06	3	< 0.1%

Value	Count	Frequency (%)
141630.61	1	< 0.1%
109030.75	1	< 0.1%
103991.94	1	< 0.1%
101378.79	1	< 0.1%
89402.64	1	< 0.1%
88805.58	1	< 0.1%
83340.33	1	< 0.1%
83192.81	1	< 0.1%
79621.2	1	< 0.1%
77451.26	1	< 0.1%

Promotion4
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1798
Distinct (%)	98.8%
Missing	4436
Missing (%)	70.9%
Infinite	0
Infinite (%)	0.0%
Mean	3465.952501

Minimum	0.41
Maximum	67474.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	0.41
5-th percentile	23.752
Q1	499.895
median	1532.63
Q3	3640.905
95-th percentile	13114.42
Maximum	67474.85
Range	67474.44
Interquartile range (IQR)	3141.01

Descriptive statistics

Standard deviation	6413.116294
Coefficient of variation (CV)	1.850318575
Kurtosis	28.70315883
Mean	3465.952501
Median Absolute Deviation (MAD)	1231
Skewness	4.744796878
Sum	6304567.6
Variance	41128060.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	4	0.1%
4	3	< 0.1%
2	3	< 0.1%
17	2	< 0.1%
12	2	< 0.1%
2.5	2	< 0.1%
657.56	2	< 0.1%
67.72	2	< 0.1%
5	2	< 0.1%
22.5	2	< 0.1%
Other values (1788)	1795	28.7%
(Missing)	4436	70.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.41	1	< 0.1%
0.46	1	< 0.1%
0.78	1	< 0.1%
0.87	1	< 0.1%
0.92	1	< 0.1%
1.5	1	< 0.1%
1.88	1	< 0.1%
1.98	1	< 0.1%
2	3	< 0.1%
2.28	1	< 0.1%

Value	Count	Frequency (%)
67474.85	1	< 0.1%
57817.56	1	< 0.1%
57815.43	1	< 0.1%
53603.99	1	< 0.1%
52739.02	1	< 0.1%
48403.53	1	< 0.1%
48159.86	1	< 0.1%
48086.64	1	< 0.1%
47452.43	1	< 0.1%
46238.28	1	< 0.1%

Promotion5
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	2114
Distinct (%)	> 99.9%
Missing	4140
Missing (%)	66.2%
Infinite	0
Infinite (%)	0.0%
Mean	4518.993173

Minimum	135.16
Maximum	108519.28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	135.16
5-th percentile	671.815
Q1	1742.305
median	3226.41
Q3	5444.03
95-th percentile	10978.358
Maximum	108519.28
Range	108384.12
Interquartile range (IQR)	3701.725

Descriptive statistics

Standard deviation	6048.661908
Coefficient of variation (CV)	1.338497687
Kurtosis	106.8102016
Mean	4518.993173
Median Absolute Deviation (MAD)	1656.68
Skewness	8.179740726
Sum	9557670.56
Variance	36586310.87
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2743.18	2	< 0.1%
1987.38	1	< 0.1%
3942.03	1	< 0.1%
6256.02	1	< 0.1%
3413.9	1	< 0.1%
6207.39	1	< 0.1%
5199.2	1	< 0.1%
11604.37	1	< 0.1%
24475.38	1	< 0.1%
492.36	1	< 0.1%
Other values (2104)	2104	33.6%
(Missing)	4140	66.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
135.16	1	< 0.1%
153.04	1	< 0.1%
153.9	1	< 0.1%
164.08	1	< 0.1%
170.64	1	< 0.1%
171.76	1	< 0.1%
212.75	1	< 0.1%
224.86	1	< 0.1%
227.12	1	< 0.1%
239.99	1	< 0.1%

Value	Count	Frequency (%)
108519.28	1	< 0.1%
105223.11	1	< 0.1%
85851.87	1	< 0.1%
63005.58	1	< 0.1%
58068.14	1	< 0.1%
57029.78	1	< 0.1%
53212.72	1	< 0.1%
37581.27	1	< 0.1%
36430.33	1	< 0.1%
36360.42	1	< 0.1%

Unemployment
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	321
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.029235651

Minimum	4.077
Maximum	14.313
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	4.077
5-th percentile	5.401
Q1	6.9165
median	7.906
Q3	8.622
95-th percentile	12.187
Maximum	14.313
Range	10.236
Interquartile range (IQR)	1.7055

Descriptive statistics

Standard deviation	1.874874599
Coefficient of variation (CV)	0.2335059874
Kurtosis	2.666559273
Mean	8.029235651
Median Absolute Deviation (MAD)	0.838
Skewness	1.211816448
Sum	50222.869
Variance	3.515154762
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.099	78	1.2%
8.163	56	0.9%
7.852	56	0.9%
6.565	52	0.8%
6.891	52	0.8%
7.057	52	0.8%
7.441	52	0.8%
7.931	52	0.8%
8.2	52	0.8%
7.343	50	0.8%
Other values (311)	5703	91.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.077	13	0.2%
4.125	26	0.4%
4.156	26	0.4%
4.261	26	0.4%
4.308	13	0.2%
4.42	26	0.4%
4.584	28	0.4%
4.607	13	0.2%
4.781	26	0.4%
5.114	24	0.4%

Value	Count	Frequency (%)
14.313	42	0.7%
14.18	39	0.6%
14.099	39	0.6%
14.021	36	0.6%
13.975	24	0.4%
13.736	39	0.6%
13.503	42	0.7%
12.89	39	0.6%
12.187	39	0.6%
11.627	39	0.6%

IsHoliday
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 KiB

False	5805
True	450

Common Values
Chart

Value	Count	Frequency (%)
False	5805	92.8%
True	450	7.2%

Weekly_Sales
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	6255
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1047619.074

Minimum	209986.25
Maximum	3818686.45
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.0 KiB

Quantile statistics

Minimum	209986.25
5-th percentile	308361.488
Q1	553869.475
median	960476.1
Q3	1421209.375
95-th percentile	2050440.157
Maximum	3818686.45
Range	3608700.2
Interquartile range (IQR)	867339.9

Descriptive statistics

Standard deviation	565436.1856
Coefficient of variation (CV)	0.5397345273
Kurtosis	0.06879449217
Mean	1047619.074
Median Absolute Deviation (MAD)	425897.32
Skewness	0.6733344437
Sum	6552857307
Variance	3.1971808 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1643690.9	1	< 0.1%
438523.24	1	< 0.1%
1332261.01	1	< 0.1%
1366193.35	1	< 0.1%
1384870.51	1	< 0.1%
1344354.41	1	< 0.1%
1473386.75	1	< 0.1%
1543947.23	1	< 0.1%
1469252.05	1	< 0.1%
425410.04	1	< 0.1%
Other values (6245)	6245	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
209986.25	1	< 0.1%
213538.32	1	< 0.1%
215359.21	1	< 0.1%
219804.85	1	< 0.1%
220060.35	1	< 0.1%
224031.19	1	< 0.1%
224294.39	1	< 0.1%
224639.76	1	< 0.1%
224806.96	1	< 0.1%
226702.36	1	< 0.1%

Value	Count	Frequency (%)
3818686.45	1	< 0.1%
3766687.43	1	< 0.1%
3749057.69	1	< 0.1%
3676388.98	1	< 0.1%
3595903.2	1	< 0.1%
3556766.03	1	< 0.1%
3555371.03	1	< 0.1%
3526713.39	1	< 0.1%
3487986.89	1	< 0.1%
3436007.68	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	Store	Date	Temperature	Fuel_Price	Promotion1	Promotion2	Promotion3	Promotion4	Promotion5	Unemployment	IsHoliday	Weekly_Sales
0	1	1	05/02/2010	42.31	2.572	NaN	NaN	NaN	NaN	NaN	8.106	False	1643690.90
1	2	1	12/02/2010	38.51	2.548	NaN	NaN	NaN	NaN	NaN	8.106	True	1641957.44
2	3	1	19/02/2010	39.93	2.514	NaN	NaN	NaN	NaN	NaN	8.106	False	1611968.17
3	4	1	26/02/2010	46.63	2.561	NaN	NaN	NaN	NaN	NaN	8.106	False	1409727.59
4	5	1	05/03/2010	46.50	2.625	NaN	NaN	NaN	NaN	NaN	8.106	False	1554806.68
5	6	1	12/03/2010	57.79	2.667	NaN	NaN	NaN	NaN	NaN	8.106	False	1439541.59
6	7	1	19/03/2010	54.58	2.720	NaN	NaN	NaN	NaN	NaN	8.106	False	1472515.79
7	8	1	26/03/2010	51.45	2.732	NaN	NaN	NaN	NaN	NaN	8.106	False	1404429.92
8	9	1	02/04/2010	62.27	2.719	NaN	NaN	NaN	NaN	NaN	7.808	False	1594968.28
9	10	1	09/04/2010	65.86	2.770	NaN	NaN	NaN	NaN	NaN	7.808	False	1545418.53

Last rows

	id	Store	Date	Temperature	Fuel_Price	Promotion1	Promotion2	Promotion3	Promotion4	Promotion5	Unemployment	IsHoliday	Weekly_Sales
6245	6246	45	27/07/2012	77.20	3.647	5753.81	167.95	1.23	9181.48	3156.06	8.684	False	711671.58
6246	6247	45	03/08/2012	76.58	3.654	24853.05	39.56	17.96	11142.69	2768.32	8.684	False	725729.51
6247	6248	45	10/08/2012	78.65	3.722	17868.84	50.60	57.66	2593.93	1890.59	8.684	False	733037.32
6248	6249	45	17/08/2012	75.71	3.807	3657.79	6.00	0.30	1630.50	3794.22	8.684	False	722496.93
6249	6250	45	24/08/2012	72.62	3.834	7936.20	58.38	22.00	5518.07	2291.97	8.684	False	718232.26
6250	6251	45	31/08/2012	75.09	3.867	23641.30	6.00	92.93	6988.31	3992.13	8.684	False	734297.87
6251	6252	45	07/09/2012	75.70	3.911	11024.45	12.80	52.63	1854.77	2055.70	8.684	True	766512.66
6252	6253	45	14/09/2012	67.87	3.948	11407.95	NaN	4.30	3421.72	5268.92	8.684	False	702238.27
6253	6254	45	21/09/2012	65.32	4.038	8452.20	92.28	63.24	2376.38	8670.40	8.684	False	723086.20
6254	6255	45	28/09/2012	64.88	3.997	4556.61	20.64	1.50	1601.01	3288.25	8.684	False	713173.95

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows